Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query, Unauthorized Open of the Drawer, etc. | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
TypeCode | A code that describes the type of control transaction, i.e. period close, etc. .e.g PeriodOpen, PeriodClose, POSStartOfDay, POSEndOfDay, POSNoSale, etc... | TY_TRN_CTL | Code4 | char(4) | |